timestamp calculations - Mailing list pgsql-general

From Steve Leibel
Subject timestamp calculations
Date
Msg-id v04210122b69663a58cdd@[24.168.80.161]
Whole thread Raw
In response to option to log just queries with some error - pgsql 7.1  (Tomaz Borstnar <tomaz.borstnar@over.net>)
Responses Re: timestamp calculations  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List pgsql-general
Hello,

I'm converting a mysql db to postgres and ran into this line of code:

   $SQL = "select username from users where user_id = ? AND session = ?
           AND ADDDATE(last_login, INTERVAL 30 MINUTE)>CURRENT_TIMESTAMP()

How do I implement adddate to get this kind of funcionality?

Thanks,

Steve Leibel

pgsql-general by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: The type int8 and the use of indexes
Next
From: Stephan Szabo
Date:
Subject: Re: timestamp calculations